<?php
  require('../action/db.php');
  require('/usr/local/lib/php/Smarty/Smarty.class.php');
  /* 这里必须起别名 否则 两个表的id会冲突覆盖*/
  $rs = $db->Execute('select MOVIE_QUEUE.id,SPIDER_PRODUCT.id as spider_id,video_url,product_name from MOVIE_QUEUE,SPIDER_PRODUCT  where video_status=\'wait_verify\' and SPIDER_PRODUCT.id=MOVIE_QUEUE.video_product_id');
  $video_wait_list = $rs->getRows();
  //var_dump($video_wait_list);
  $smarty = new Smarty();

  $smarty->setTemplateDir('../smarty/templates');
  $smarty->setCompileDir('../smarty/templates_c');
  $smarty->setCacheDir('../smarty/cache');
  $smarty->setConfigDir('../smarty/configs');

  $smarty->assign('video_wait_list', $video_wait_list);

  $smarty->display('video_verify.tpl');
?>
